﻿CREATE TABLE [dbo].[Vendors] (
    [vendorID]               SMALLINT       IDENTITY (1, 1) NOT NULL,
    [vendorName]             NVARCHAR (50)  NOT NULL,
    [vendorAddress1]         NVARCHAR (200) NOT NULL,
    [vendorAddress2]         NVARCHAR (200) NULL,
    [vendorCity]             NVARCHAR (100) NOT NULL,
    [vendorState]            NVARCHAR (2)   NOT NULL,
    [vendorZip]              NCHAR (10)     NOT NULL,
    [vendorLicenseNumber]    NVARCHAR (500) NOT NULL,
    [vendorContactFirstName] NVARCHAR (100) NULL,
    [vendorContactLastName]  NVARCHAR (100) NULL,
    [vendorContactPhone]     NVARCHAR (50)  NULL,
    [vendorContactEmail]     NVARCHAR (50)  NULL
);



